Delete Column

Command Prototype

Excel.DeleteColumn(objExcelWorkBook,sheet,strCell,bSave)

Command Description

Delete a column from the sheet

Parameter Description

Required Parameter

objExcelWorkBook--Excel workbook object (workbook opened with "Open Excel" command (Excel.OpenExcel))

sheet--If a string is used, it refers to the name of the specified sheet; if a number is used, it refers to the index of the specified sheet (starting from 0)

strCell--The specified column, can be positioned using a cell name like 'A1' or directly using a numeric column number

bSave--Save immediately after an operation